Overview

Dataset Statistics

Number of Variables 29
Number of Rows 53572
Missing Cells 0
Missing Cells (%) 0.0%
Duplicate Rows 0
Duplicate Rows (%) 0.0%
Total Size in Memory 16.4 MB
Average Row Size in Memory 320.4 B

Variable Types

Numerical 26
Categorical 2
DateTime 1

Variables

sic

numerical

Distinct Count 377
Unique (%) 0.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 837.1 KB
Mean 4724.0779
Minimum 100
Maximum 9995
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 100
5-th Percentile 1382
Q1 3420
Median 3843
Q3 7310
95-th Percentile 8060
Maximum 9995
Range 9895
IQR 3890

Descriptive Statistics

Mean 4724.0779
Standard Deviation 2082.6301
Variance 4.3373e+06
Sum 2.5308e+08
Skewness 0.2248
Kurtosis -1.0395
Coefficient of Variation 0.4409

cik

numerical

Distinct Count 3602
Unique (%) 6.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 837.1 KB
Mean 1.0747e+06
Minimum 2034
Maximum 1.8404e+06
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 2034
5-th Percentile 57528
Q1 876523
Median 1.1068e+06
Q3 1.4192e+06
95-th Percentile 1.6414e+06
Maximum 1.8404e+06
Range 1.8384e+06
IQR 542719

Descriptive Statistics

Mean 1.0747e+06
Standard Deviation 455987.3134
Variance 2.0792e+11
Sum 5.7573e+10
Skewness -0.8926
Kurtosis 0.1681
Coefficient of Variation 0.4243

countryba

categorical

Distinct Count 46
Unique (%) 0.1%
Missing 0
Missing (%) 0.0%
Memory Size 3.4 MB

Length

Mean 2
Standard Deviation 0
Median 2
Minimum 2
Maximum 2

Sample

1st row US
2nd row US
3rd row US
4th row US
5th row US

Letter

Count 107144
Lowercase Letter 0
Space Separator 0
Uppercase Letter 107144
Dash Punctuation 0
Decimal Number 0

name

categorical

Distinct Count 3594
Unique (%) 6.7%
Missing 0
Missing (%) 0.0%
Memory Size 4.4 MB

Length

Mean 20.3552
Standard Deviation 7.5195
Median 20
Minimum 3
Maximum 55

Sample

1st row ACETO CORP
2nd row ACETO CORP
3rd row ACETO CORP
4th row ACETO CORP
5th row ACETO CORP

Letter

Count 930113
Lowercase Letter 0
Space Separator 108907
Uppercase Letter 930113
Dash Punctuation 889
Decimal Number 998

ddate

datetime

Distinct Count 37
Unique (%) 0.1%
Missing 0
Missing (%) 0.0%
Memory Size 418.7 KB
Minimum 2012-03-31 00:00:00
Maximum 2021-03-31 00:00:00

solvency_debt_ratio

numerical

Distinct Count 53479
Unique (%) 99.8%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 837.1 KB
Mean 0.6341
Minimum 0
Maximum 6.5331
Zeros 35
Zeros (%) 0.1%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 0
5-th Percentile 0.1351
Q1 0.3358
Median 0.5322
Q3 0.7386
95-th Percentile 1.3944
Maximum 6.5331
Range 6.5331
IQR 0.4028

Descriptive Statistics

Mean 0.6341
Standard Deviation 0.5867
Variance 0.3442
Sum 33970.0246
Skewness 4.5887
Kurtosis 30.1968
Coefficient of Variation 0.9252

liquid_current_ratio

numerical

Distinct Count 53447
Unique (%) 99.8%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 837.1 KB
Mean 2.4778
Minimum 0
Maximum 18.0877
Zeros 39
Zeros (%) 0.1%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 0
5-th Percentile 0.3871
Q1 1.1228
Median 1.835
Q3 3.0424
95-th Percentile 6.9293
Maximum 18.0877
Range 18.0877
IQR 1.9196

Descriptive Statistics

Mean 2.4778
Standard Deviation 2.1805
Variance 4.7546
Sum 132740.4282
Skewness 2.3074
Kurtosis 7.2554
Coefficient of Variation 0.88

liquid_quick_ratio

numerical

Distinct Count 53427
Unique (%) 99.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 837.1 KB
Mean 1.6119
Minimum 0
Maximum 15.2012
Zeros 98
Zeros (%) 0.2%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 0
5-th Percentile 0.1572
Q1 0.6215
Median 1.1231
Q3 1.9703
95-th Percentile 4.904
Maximum 15.2012
Range 15.2012
IQR 1.3487

Descriptive Statistics

Mean 1.6119
Standard Deviation 1.6624
Variance 2.7636
Sum 86354.9168
Skewness 2.7349
Kurtosis 10.1516
Coefficient of Variation 1.0313

liquid_cash_ratio

numerical

Distinct Count 53032
Unique (%) 99.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 837.1 KB
Mean 0.992
Minimum 0
Maximum 11.719
Zeros 464
Zeros (%) 0.9%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 0
5-th Percentile 0.01222
Q1 0.1414
Median 0.4552
Q3 1.182
95-th Percentile 3.9539
Maximum 11.719
Range 11.719
IQR 1.0406

Descriptive Statistics

Mean 0.992
Standard Deviation 1.4694
Variance 2.1591
Sum 53144.5577
Skewness 3.0579
Kurtosis 11.8255
Coefficient of Variation 1.4812

profit_net_margin

numerical

Distinct Count 53258
Unique (%) 99.4%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 837.1 KB
Mean -0.08217
Minimum -1.9995
Maximum 1.9938
Zeros 36
Zeros (%) 0.1%
Negatives 23592
Negatives (%) 44.0%

Quantile Statistics

Minimum -1.9995
5-th Percentile -0.9072
Q1 -0.1251
Median 0.01513
Q3 0.08361
95-th Percentile 0.2762
Maximum 1.9938
Range 3.9934
IQR 0.2087

Descriptive Statistics

Mean -0.08217
Standard Deviation 0.3895
Variance 0.1517
Sum -4402.24
Skewness -1.756
Kurtosis 6.7925
Coefficient of Variation -4.7394

profit_roa

numerical

Distinct Count 53503
Unique (%) 99.9%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 837.1 KB
Mean -0.06175
Minimum -9.718
Maximum 12.8227
Zeros 36
Zeros (%) 0.1%
Negatives 23615
Negatives (%) 44.1%

Quantile Statistics

Minimum -9.718
5-th Percentile -0.598
Q1 -0.09247
Median 0.01364
Q3 0.06984
95-th Percentile 0.2089
Maximum 12.8227
Range 22.5407
IQR 0.1623

Descriptive Statistics

Mean -0.06175
Standard Deviation 0.4554
Variance 0.2074
Sum -3307.8435
Skewness -1.8826
Kurtosis 114.5052
Coefficient of Variation -7.3749

active_acp

numerical

Distinct Count 53035
Unique (%) 99.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 837.1 KB
Mean 51.4807
Minimum 0
Maximum 326.5468
Zeros 313
Zeros (%) 0.6%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 0
5-th Percentile 4.5214
Q1 29.4528
Median 48.4515
Q3 65.7586
95-th Percentile 106.9321
Maximum 326.5468
Range 326.5468
IQR 36.3059

Descriptive Statistics

Mean 51.4807
Standard Deviation 36.3848
Variance 1323.8512
Sum 2.7579e+06
Skewness 2.2749
Kurtosis 10.4911
Coefficient of Variation 0.7068

med_solvency_debt_ratio

numerical

Distinct Count 377
Unique (%) 0.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 837.1 KB
Mean 0.5337
Minimum 0.03147
Maximum 3.0266
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 0.03147
5-th Percentile 0.3403
Q1 0.4427
Median 0.5278
Q3 0.5992
95-th Percentile 0.7981
Maximum 3.0266
Range 2.9951
IQR 0.1565

Descriptive Statistics

Mean 0.5337
Standard Deviation 0.1541
Variance 0.02375
Sum 28589.2743
Skewness 2.5206
Kurtosis 28.5909
Coefficient of Variation 0.2888

med_liquid_current_ratio

numerical

Distinct Count 377
Unique (%) 0.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 837.1 KB
Mean 2.0156
Minimum 0.1371
Maximum 9.3204
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 0.1371
5-th Percentile 0.8817
Q1 1.4339
Median 1.7733
Q3 2.5952
95-th Percentile 3.6994
Maximum 9.3204
Range 9.1833
IQR 1.1613

Descriptive Statistics

Mean 2.0156
Standard Deviation 0.8571
Variance 0.7346
Sum 107977.1542
Skewness 0.8105
Kurtosis 0.5975
Coefficient of Variation 0.4252

med_liquid_quick_ratio

numerical

Distinct Count 377
Unique (%) 0.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 837.1 KB
Mean 1.2108
Minimum 0.0588
Maximum 7.8005
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 0.0588
5-th Percentile 0.4869
Q1 0.8327
Median 1.1782
Q3 1.585
95-th Percentile 2.2109
Maximum 7.8005
Range 7.7417
IQR 0.7523

Descriptive Statistics

Mean 1.2108
Standard Deviation 0.5059
Variance 0.2559
Sum 64867.4669
Skewness 0.5003
Kurtosis 0.9256
Coefficient of Variation 0.4178

med_liquid_cash_ratio

numerical

Distinct Count 377
Unique (%) 0.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 837.1 KB
Mean 0.5749
Minimum 0.00297
Maximum 7.4628
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 0.00297
5-th Percentile 0.1005
Q1 0.2335
Median 0.4838
Q3 0.7949
95-th Percentile 1.3991
Maximum 7.4628
Range 7.4598
IQR 0.5613

Descriptive Statistics

Mean 0.5749
Standard Deviation 0.4064
Variance 0.1652
Sum 30798.3384
Skewness 1.0288
Kurtosis 3.3144
Coefficient of Variation 0.7069

med_profit_net_margin

numerical

Distinct Count 377
Unique (%) 0.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 837.1 KB
Mean -0.00062906
Minimum -1.7985
Maximum 0.7747
Zeros 0
Zeros (%) 0.0%
Negatives 21637
Negatives (%) 40.4%

Quantile Statistics

Minimum -1.7985
5-th Percentile -0.1027
Q1 -0.04002
Median 0.007989
Q3 0.03234
95-th Percentile 0.08929
Maximum 0.7747
Range 2.5732
IQR 0.07236

Descriptive Statistics

Mean -0.00062906
Standard Deviation 0.07029
Variance 0.00494
Sum -33.6997
Skewness -1.2361
Kurtosis 20.1505
Coefficient of Variation -111.7334

med_profit_roa

numerical

Distinct Count 377
Unique (%) 0.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 837.1 KB
Mean 0.001189
Minimum -1.4473
Maximum 1.0012
Zeros 0
Zeros (%) 0.0%
Negatives 21637
Negatives (%) 40.4%

Quantile Statistics

Minimum -1.4473
5-th Percentile -0.07962
Q1 -0.02136
Median 0.008081
Q3 0.0327
95-th Percentile 0.06336
Maximum 1.0012
Range 2.4484
IQR 0.05406

Descriptive Statistics

Mean 0.001189
Standard Deviation 0.05798
Variance 0.003361
Sum 63.6728
Skewness -5.4103
Kurtosis 91.0606
Coefficient of Variation 48.7798

med_active_acp

numerical

Distinct Count 377
Unique (%) 0.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 837.1 KB
Mean 47.6383
Minimum 0
Maximum 207.6846
Zeros 3
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 0
5-th Percentile 15.4072
Q1 40.0071
Median 51.5979
Q3 57.0106
95-th Percentile 67.8512
Maximum 207.6846
Range 207.6846
IQR 17.0036

Descriptive Statistics

Mean 47.6383
Standard Deviation 16.3972
Variance 268.8686
Sum 2.5521e+06
Skewness -0.06368
Kurtosis 4.9056
Coefficient of Variation 0.3442

y_liquid_current_ratio

numerical

Distinct Count 2
Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 627.8 KB
Mean 0.5017
Minimum 0
Maximum 1
Zeros 26694
Zeros (%) 49.8%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 1
Q3 1
95-th Percentile 1
Maximum 1
Range 1
IQR 1

Descriptive Statistics

Mean 0.5017
Standard Deviation 0.5
Variance 0.25
Sum 26878
Skewness -0.006869
Kurtosis -2
Coefficient of Variation 0.9966

y_liquid_quick_ratio

numerical

Distinct Count 2
Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 627.8 KB
Mean 0.5017
Minimum 0
Maximum 1
Zeros 26694
Zeros (%) 49.8%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 1
Q3 1
95-th Percentile 1
Maximum 1
Range 1
IQR 1

Descriptive Statistics

Mean 0.5017
Standard Deviation 0.5
Variance 0.25
Sum 26878
Skewness -0.006869
Kurtosis -2
Coefficient of Variation 0.9966

y_liquid_cash_ratio

numerical

Distinct Count 2
Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 627.8 KB
Mean 0.5017
Minimum 0
Maximum 1
Zeros 26694
Zeros (%) 49.8%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 1
Q3 1
95-th Percentile 1
Maximum 1
Range 1
IQR 1

Descriptive Statistics

Mean 0.5017
Standard Deviation 0.5
Variance 0.25
Sum 26878
Skewness -0.006869
Kurtosis -2
Coefficient of Variation 0.9966

y_profit_net_margin

numerical

Distinct Count 2
Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 627.8 KB
Mean 0.5017
Minimum 0
Maximum 1
Zeros 26693
Zeros (%) 49.8%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 1
Q3 1
95-th Percentile 1
Maximum 1
Range 1
IQR 1

Descriptive Statistics

Mean 0.5017
Standard Deviation 0.5
Variance 0.25
Sum 26879
Skewness -0.006944
Kurtosis -2
Coefficient of Variation 0.9965

y_profit_roa

numerical

Distinct Count 2
Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 627.8 KB
Mean 0.5017
Minimum 0
Maximum 1
Zeros 26694
Zeros (%) 49.8%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 1
Q3 1
95-th Percentile 1
Maximum 1
Range 1
IQR 1

Descriptive Statistics

Mean 0.5017
Standard Deviation 0.5
Variance 0.25
Sum 26878
Skewness -0.006869
Kurtosis -2
Coefficient of Variation 0.9966

y_solvency_debt_ratio

numerical

Distinct Count 2
Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 627.8 KB
Mean 0.4983
Minimum 0
Maximum 1
Zeros 26878
Zeros (%) 50.2%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 1
95-th Percentile 1
Maximum 1
Range 1
IQR 1

Descriptive Statistics

Mean 0.4983
Standard Deviation 0.5
Variance 0.25
Sum 26694
Skewness 0.006869
Kurtosis -2
Coefficient of Variation 1.0034

y_active_acp

numerical

Distinct Count 2
Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 627.8 KB
Mean 0.4983
Minimum 0
Maximum 1
Zeros 26879
Zeros (%) 50.2%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 1
95-th Percentile 1
Maximum 1
Range 1
IQR 1

Descriptive Statistics

Mean 0.4983
Standard Deviation 0.5
Variance 0.25
Sum 26693
Skewness 0.006944
Kurtosis -2
Coefficient of Variation 1.0035

y_ttl

numerical

Distinct Count 8
Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 837.1 KB
Mean 3.5052
Minimum 0
Maximum 7
Zeros 4162
Zeros (%) 7.8%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 2
Median 4
Q3 5
95-th Percentile 7
Maximum 7
Range 7
IQR 3

Descriptive Statistics

Mean 3.5052
Standard Deviation 2.0358
Variance 4.1445
Sum 187778
Skewness 0.002012
Kurtosis -0.9824
Coefficient of Variation 0.5808

y_ttl_avg

numerical

Distinct Count 90
Unique (%) 0.2%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 837.1 KB
Mean 3.5052
Minimum 3.5
Maximum 5
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 3.5
5-th Percentile 3.5
Q1 3.5
Median 3.5
Q3 3.5054
95-th Percentile 3.5238
Maximum 5
Range 1.5
IQR 0.005376

Descriptive Statistics

Mean 3.5052
Standard Deviation 0.02197
Variance 0.00048283
Sum 187778
Skewness 38.8434
Kurtosis 2445.0199
Coefficient of Variation 0.006269

y

numerical

Distinct Count 2
Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 627.8 KB
Mean 0.5022
Minimum 0
Maximum 1
Zeros 26669
Zeros (%) 49.8%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 1
Q3 1
95-th Percentile 1
Maximum 1
Range 1
IQR 1

Descriptive Statistics

Mean 0.5022
Standard Deviation 0.5
Variance 0.25
Sum 26903
Skewness -0.008736
Kurtosis -1.9999
Coefficient of Variation 0.9957

Interactions

Correlations

Missing Values